Payroll utilities
These utilities are designed to post calculated values to the database.
Accessing these reports
The reports listed in this section are located in \Axiom\Reports Library\Management Reporting Utilities\Payroll. For instructions, see Browsing the Report Library.
You can also access them from the Bud Admin task pane. In the Financial Reporting section, click Financial Utilities > Payroll.
Use this utility to accrue for both hours and dollars from your biweekly payroll load (Payroll26) into the monthly data tables (Payroll12).
Depending on how many years of biweekly payroll data are stored in your Axiom system, you have two utility options:
-
Biweekly to Monthly – Your organization is in their first year in Axiom and have no prior year payroll data utilize this utility.
-
Biweekly to Monthly with LY – Your organization has more than one year of historical payroll data to capture the days of the year-end biweekly payroll that may cross over their fiscal year utilize this utility.
In the Refresh Variables dialog, select from the following drop-downs options, and click OK:
| Option | Description |
|---|---|
| Choose Year (Current Year or Last Year | Depending on what biweekly payrolls you want to accrue, select CYA (Current Year) or LYA (Last Year) . |
| Choose Payroll Sequence (Hours, Dllrs, Stats) |
Select Hours or Dllrs. NOTE: These need to be run individually so once you run one (Hours) you will have to then run the other (Dllrs). |
| Post results to the database? | To post the results to the Axiom database, select Yes; otherwise, select No. |
TIP: Ensure that the number of FY days in First Pay Period are correct. If they are not, review the pay period dates on the Custom Tables > Payroll tab.
Click image to view full size
In the File Processing task pane, click Process file multipass to run the utility by department and post the values to the database. Repeat this step for the Hours by refreshing the report variables, select Hours from the refresh variable, and then Process File multipass. If you also load statistics into you biweekly payroll tables, you can also run this utility to move the statistics to your financial data source.
Click image to view full size
BiWeekly to Monthly with LY
Use this utility to post accrued biweekly hours or dollars from the Payroll27 tables to the Payroll12 tables. The first period of the year is calculated using the final LY pay period.
Click image to view full size
Use this utility to post reverse-accrued budgeted monthly hours from the Payroll12 tables to biweekly amounts and post them to the Payroll27 tables for labor or productivity reporting.
Click image to view full size
If payroll hours are not coming through your GL Import, you can move your hours from the Payroll12 data tables created from the previous process to your Financial tables by running the Monthly to GL accrual utility.
IMPORTANT: Only run this utility if you are not loading hours from your GL via the GL12Month or Monthly Statistics imports.
Click image to view full size
NOTE: Use the Monthly to BiWeekly utility to take budgeted Payroll12 data and reverse accrue it to a biweekly data set.
